Amiga Collections: Amiga Club Hoorn

home *** CD-ROM | disk | FTP | other *** search

/ Amiga Collections: Amiga Club Hoorn / ACH ClubDiskette No.36 (1997)(Amiga Club Hoorn)(NL)[FFS].zip / ACH ClubDiskette No.36 (1997)(Amiga Club Hoorn)(NL)[FFS].adf / Utilities8.DMS / Utilities8.adf / FHSpreadII.doc < prev next >

Wrap

Text File | 1992-09-02 | 29KB | 840 lines

document FHSpreadII documentation FHSpreadII V0.3 guide 21/04/1996 Guide version V0.2 Developed by Frank Hartog Written in full assembly 0. Introduction About four years ago I started writing a spreadsheet program that had to be easy to use and contain al the necessary features I need. The first versions where written with GFA-basic. However GFA-basic was a very good tool to develop programs, I started all over again writing a new version in assembler two years ago (1994). Several versions of the GFA-basic version of FHSpread can be found in the Fred Fish collection.(There was even a very small article about FHSpread in the AmigaShopper.) The development of FHSpreadII took a little more time than I expected because of my graduation and other hobbies who became also important for me. Unfortunately FHSpreadII is totally incompatible with FHSpread because of a change in file format and other methods of memory-usage and formula coding. If there are enough people who like to have a possibility of converting old FHSpread files to FHSpreadII file , I will try to write a conversion program. I hope that you will enjoy the programm. 1. Disclaimer - Disclaimer - The author of FHSpreadII can not be held responsible for any damage that this program or the manual that came with it might cause. If you are using FHSpreadII, you will do so at YOUR OWN RISK. 2. System requirements This programm should work fine on every AMIGA with system 2.04 and higher. Its recommended to use at least asl.library V38 because of better file requesters and the option for a screen requester. This programm is written system friendly, and is tested with enforcer. However there is always a possibility of some hidden bug that can crash your computer. 3. Installing FHSpreadII To install FHS is very simple. Just drag the FHSpreadII drawer to your harddisk and that is it. It is not necessary to make any assigns. Execept if you like to start FHS from selecting a FHS project by mouse. Then look at chapter `Starting the programm'. Make sure that Times.font 12pts and 24pts are in you font directory otherwise the programm would not show graphical presentations of your data!! 4. Starting the programm There are three ways of starting FHSpreadII: 1) Type FHS from the shell 2) Double click on the FHS icon 3) Double click on a FHS project or projects Both options 1 and 2 will show you an empty sheet on which you can start. For option 3 the following assign command has to be placed in your user-startup file: ASSIGN FHSpreadII: <pathname>/FHSpreadII The selected project(s) will then be automatic loaded. 5. General operation instructions - While entering text or a formula its always possible to abort this by pressing Esc. - The overall way of changing attributes of the cells is as follows: 1) Select a list (see `Selecting Cells'). 2) Select an option from the menu or use one of the options from one the requesters. 5.1. Selecting Cells A cell or a group of cells can be selected by pressing the left mousebutton and then move the mouse across the cells you want to select. A rectangle will mark the selected array. An other way of selecting cells is as follows. Place the cursor on the first cell you want to select. Press F1 and than use the arrowkeys to move the cursor. Also this time a rectangle will mark the select array. The array can be put away by moving the cursor by mouse or by pressing F1. A selected group of cells will be called a LIST. A LIST can be used to e.g. create labels with use of the `Labels-requester' or formatting cells (with use of the `Cells' menu). 5.2. Entering text A line of text can be entered in two ways: 1) Just start typing and end with pressing the ENTER button or buy using one of the arrowkeys. The cursor will then automatic go to the next cell. 2) Press F2 and start typing. At the end of the line you have to press ENTER again. The arrowkeys can be used to scroll trough the text. The textline can be started with one of the follow three align-characters: " :This will align your text to the right of the cell. ^ :This will align your text to the centers of the cell. * :This will align your text to the left of the cell. 5.3. Entering formulas First of all: FHSpreadII handles all commands in a formula in the order the way they are entered. So for example 1+2*3 will have the result 9 and not 7. If you want 7 as a result you should enter the formula like this: 1+(2*3) - If a formula begins with a mathematical function like SIN or COS you should first enter an =.(e.g. =SIN(1)) - A relative reference to a value of an other cell can be made by entering the address of that cell in the formula.(e.g. =SIN(A12) this will calculate the sinus of the value in cell of column A and row 12). - An absolute reference to a value of an other cell can be made by entering the address of that cell in combination with $-signs. e.g. =SIN($A$12) column and row are absolute =SIN($A12) only column is absolute =SIN(A$12) only row is absolute - This is the same way for use of lists (see `Selecting Cells') A list in a formula can look like this: B1|C11 $B1|C11 $B$1|$C11 etc... (e.g. =SUM(B1|C11) will sum all the cells with in the rectangle described by B1|C11) Instead of adresses or lists also labels can be used. More info about labels can be found in `Labels-requester'. Entering a formula can be done by keyboard but also with the mouse using the `Function-requester'. 5.4. Requesters Most system requesters can be answered by pressing the gadgets or by pressing the first character of the gadgettext on the keyboard. Requester with only one button with the text CONTINUE, can be answered by pressing the CONTINUE gadget with the mouse, by pressing c or C on the keyboard or by pressing the ENTER button on the keyboard. The custom requesters like the `Labels-requester' or the `Function-requester' can be closed by pressing q or Q on the keyboard or by pressing the closegadget with the mouse. 5.4.1. Printerrequester This requester takes care of printing your sheet on a printer or print it to an ASCII file. In the Destination gadget a device name or a file name can be entered. The default contents of this gadget will be PRT:. Under the Destination gadgets are two checkbox gadgets: - If the NLQ checkbox is selected the sheet will be printed in Near Letter Quality (that is for oldfashioned 9 pin dotmatrix printers) - If the Print Protected Cells Bold checkbox is selected all the cells that are protected with the option protect from the `Cells' menu will be printed bold. In the Print Range gadget a list of cells can be entered. This can also be done by selecting a list (see `Selecting Cells') from the sheet and then select the Get Range gadget on the printer requester. If you like to see what range of cells will be printed press the Show Range gadget. Finally if all gadgets are set the way you want them press the Print gadget and the sheet will be printed to your printer , file or other device. 5.4.2. Labels-requester This requester has to be used for creating labels. A label is a name that can be given to a cell or a list of cells. In this way you can make your spreadsheet more understandable when editing formulas. 5.4.2.1. Creating Labels Labels may be used in formulas instead of cell addresses and can be used both relative and absolute by using the $-sign. Creating a label has to be done by doing the following handlings: 1) Select a cell or a list of cells (see 'Selecting Cells'). 2) Activate the Label requester by selecting 'Labels' from the 'Sheet' menu, by pressing right_AMIGA_K or if the requester is already opened move the mouse over its window and press the left mousebutton. - The selected cell or list will be shown in the list stringgadget. 3) Now a name has to be entered in the list name gadget. This gadget can be activated by mouse or by pressing N or n on the keyboard. 4) After a name has been entered, the Add gadget at the bottom of of this requester will be activated. Press the gadget by mouse or press A or a on the keyboard and the label is created and will be show in the listview gadget. Instead of step 1 you can also start at step 2 and enter a list manually from the keyboard in the listgadget. 5.4.2.2. Use in formulas While entering formulas the Labels-requester can also be used. - Select a label from the listview gadget. A row of gadgets at the bottom will be activated. - Select the Copy gadget by mouse or by pressing C or c on the keyboard. The name of the label will be copied to the formula that is edited at the moment. 5.4.2.3. Deleting labels A label can be deleted by selecting a label from the listview gadget. A row of gadgets at the bottom will be activated. Select the Del gadget by mouse or press D or d on the keyboard. The label will be deleted. This will not effect the formulas that had references to the label. Instead of the labelname the formula will now show a list or a cell address. 5.4.2.4. Show labels The cell or list of cells that belong to a label can be made visible by doing the following. - Select a label from the listview gadget A row of gadgets at the bottom will be activated. - Select the Show gadget by mouse or by pressing S or s on the keyboard. The cell or list of cells will be visible on the spreadsheet. 5.4.3. Column Width-requester The columnwidth can be changed by doing the following: -Place the cursor in the column of which you like to change the width from or select more columns as described in `Selecting Cells'. -Open the Column Width-requester by selecting Columnwidth from the `Sheet' menu or by pressing right_AMIGA_W on the keyboard. -Enter a number between 1 and 40 in the stringgadget. -Press ENTER and the columnwidth will be changed. 5.4.4. Goto-requester -Open the Column Goto-requester by selecting Goto from the `Sheet' menu or by pressing right_AMIGA_G on the keyboard. -Enter a celladdress in the string gadget and press ENTER. -If a valid cell address is entered, the cursor will be placed on the given address. 5.4.5. Fixed Digits-requester This requester can be used to set the number of digits that a cell may show. e.g. If you set a cell to 2 digits the value of PI() will be shown as 3.14. Use the + and - gadgets or the up and down arrowkeys to increase or decrease the number of digits. You can also enter a value direct into the Digits stringgadget. Use the Return to sheet gadget to return to the sheet. Or just click with the mouse on the sheet to return. 5.4.6. Graph Settings-requester In this requester has to be used to set up and graphic presentation of data. 5.4.6.1. Title stringgadget In this gadget a title for the graph can be entered. The title will then be showed above the graph. 5.4.6.2. Select ?-Range gadgets With these gadgets a list can be selected from the sheet or from listview gadget at the bottom of the requester. First select a list (see `Selecting Cells') or select a label from the listview gadget. Then select one of the Select ?-Range gadgets by mouse or press X, A, B, C, D or E on the keyboard. The stringgadgets after the Select ?-Range gadget will be filled. 5.4.6.3. Clear gadgets These gadgets can be used to clear a selected range. This will empty the string gadgets. From the keyboard this can be done by pressing Ctrl- and then A, B, C, D or E. 5.4.6.4. Checkbox gadgets These gadgets can be used to activate a rang. If a checkbox of a range is selected, the range will be shown in the graphical presentation, otherwise it won't be shown. 5.4.6.5. Enter Range manually Select one of the left stringgadgets by mouse and enter a list of cells. 5.4.6.6. Enter Range-name manually Select one of the right stringgadgets by mouse or just press X, A, B, C, D or E on the keyboard and enter a name. 5.4.6.7. The Listview gadget In the listview gadget at the bottom-left of the requester the already created labels (see `Labels-requester') are shown. These labels can be used for selecting ranges for the graphical presentation. 5.4.6.8. The Show gadget This gadget can be used to check what list a selected label from the listview gadget contains. By selecting this gadget by mouse or pressing S or s on the keyboard. The list will then be made visible on the sheet. 5.4.6.9. The cyclegadget With this gadget its possible to select the type of graphic presentation. At this moment there are 4 different types: -Stackedbars1: This will separate the negative from the positive values and will then stack all positive values above the 0-line and all negative value under the 0-line. -Stackedbars2: This will not separate the negative from the positive values but stack them all on the same bar. -Bar : This will show all separate bars. The different ranges will be shown next to each other. -Line : Will do the same as the Bar option, but instead of bars it will show lines. 5.4.6.10. The ViewGraph gadget With this gadget the graphical presentation will be made visible on its own window. This window can be close by selecting the close gadget by mouse or pressing Q or q on the keyboard. 5.4.7. Function-requester This requester contains a listviewkind gadget which shows all available mathematic functions that can be used with FHSpreadII. If you press one functions in this gadget than the name of the function will appear in the command-line. The function-requester also contains a numeric keypad at the bottom. By pressing these gadgets the formula can be edited. 5.4.8. Set Currency Symbol-requester This requester will ask for what currency text it has to place in front of the numeric data in a cell. This text will only be shown in cells which are formatted as a currency cell, which can be done from the `Cells' menu and contain a numeric value or a formula. The currency-text may be up to 20 characters (e.g. F, Bfr. or $) The currency-text can be entered in the string gadget. 5.5. The Menu The totalmenu of FHSpreadII consist of the following menu's: 5.5.1. FHSpread - FHSpread - 5.5.1.1. About About will show information about the author and programm version. The requester can be closed by selecting the continue gadget or the close gadget by mouse or press ENTER or C on the keyboard. 5.5.1.2. New New will open a new sheet in its own window. In this way its possible to have more sheets loaded in memory and exchange date between the sheets by using the `Cut', `Copy' and `Paste' functions of the `Sheet' menu. 5.5.1.3. Load Load will show a file requester from which an existing FHS project can be selected. After an selection has been made the current data in the sheet will be erased and the FHS project will be loaded into the sheet. 5.5.1.4. Save Save will write the data from the current active sheet to disk. A file requester will only pop up if the sheet is created from `New' and has a title like "Untitled". 5.5.1.5. Save_As Save_As will let you write a file to disk and will always show a filerequester. This will give you the opportunity to change the name of the project. 5.5.1.6. Print Print will activate the `Printerrequester' so the sheet can be send to printer or to an ASCII file. 5.5.1.7. Quit Quit will end all sheet that are loaded into memory. It will show some requester just to be sure you really want to quit. And you get the possibility to save your projects incase they are changed. 5.5.2. Sheet - Sheet - 5.5.2.1. Labels Labels will activate the `Labels-requester' and let you manage your labels. 5.5.2.2. Previous Window Previous Window will switch to the previous sheet in memory. 5.5.2.3. Next Window Next Window will switch to the next sheet in memory. 5.5.2.4. Column Width Column Width will activate the `Column Width-requester' and let you adjust the width of the columns in your sheet. 5.5.2.5. Cut Cut will put a selected list of cells (see `Selecting Cells') into memory and erase them from your sheet. 5.5.2.6. Copy Copy will put a selected list of cells (see `Selecting Cells') into memory but sheet intact. 5.5.2.7. Paste Paste will put a list of cells that are stored into memory with `Cut' or `Copy' back into your sheet. In this way data can be copied or moved from one sheet to the other. 5.5.2.8. Erase Erase will erase a list of cells (see `Selecting Cells') from from your sheet. This operation is definitive and can not be restored. 5.5.2.9. Goto Goto will activate the `Goto-requester' and let you place the cursor on a chosen cell. 5.5.2.10. Insert Row Insert Row will let you add rows to your sheet. If you select this function a row will be inserted on the current place of the cursor. Its also possible to insert more rows at a time. This is done by selecting a number of rows (see `Selecting Cells') and then select Insert Row from the menu. 5.5.2.11. Delete Row Delete Row will let you remove rows from your sheet. If you select this function a row will be deleted from the current place of the cursor. Its also possible to delete more rows at a time. This is done by selecting a number of rows (see `Selecting Cells') and then select Delete Row from the menu. 5.5.2.12. Insert Column Insert Column will let you add columns to your sheet. If you select this function a column will be inserted on the current place of the cursor. Its also possible to insert more columns at a time. This is done by selecting a number of columns (see `Selecting Cells') and then select Insert Column from the menu. 5.5.2.13. Delete Column Delete Column will let you remove columns from your sheet. If you select this function a column will be deleted from the current place of the cursor. Its also possible to delete more columns at a time. This is done by selecting a number of columns (see `Selecting Cells') and then select Delete Column from the menu. 5.5.3. Cells - Cells - 5.5.3.1. Left Left can be selected by mouse from the menu or by pressing Ctrl-l on the keyboard. A list of cells has to be selected first (see `Selecting Cells'). Then the contents of the cells in the list will be align to the left. 5.5.3.2. Right Right can be selected by mouse from the menu or by pressing Ctrl-r on the keyboard. A list of cells has to be selected first (see `Selecting Cells'). Then the contents of the cells in the list will be align to the right. 5.5.3.3. Center Center can be selected by mouse from the menu or by pressing Ctrl-c on the keyboard. A list of cells has to be selected first (see `Selecting Cells'). Then the contents of the cells in the list will be centered. 5.5.3.4. Currency Currency can be selected by mouse from the menu or by pressing Ctrl-v on the keyboard. A list of cells has to be selected first (see `Selecting Cells'). Then the contents of the cells in the list which contain numeric data will be shown as a valuta like dutch guilders or US dollars. To set the right type of currency the `Set Currency Symbol-requester' has to be used. The `Fixed' command from this same menu can be used to change the number of digits that will be shown after the dot. 5.5.3.5. Reset Reset can be selected by mouse from the menu or by pressing Ctrl-n on the keyboard. A list of cells has to be selected first (see `Selecting Cells'). Then format of the cells will be set to default values. 5.5.3.6. Fixed Fixed can be selected by mouse from the menu or by pressing Ctrl-f on the keyboard. A list of cells has to be selected first (see `Selecting Cells'). Then the number of digits after the dot of the cells in the list which contain numeric data can be changed from 0 to 6. This function can also be used in combination with the `Currency' function from this same menu. 5.5.3.7. Procents Procents can be selected by mouse from the menu or by pressing Ctrl-p on the keyboard. A list of cells has to be selected first (see `Selecting Cells'). Then the contents of the cells in the list which contain numeric data will be shown a factor 100 bigger and will have a % sign at the end. The `Fixed' command from this same menu can be used to change the number of digits that will be shown after the dot. 5.5.3.8. Hide Hide can be selected by mouse from the menu or by pressing Ctrl-h on the keyboard. A list of cells has to be selected first (see `Selecting Cells'). After this function has been used, the contents selected cells will not be visible in the sheet but they will stil be intact and are still valid in calculations. 5.5.3.9. Unhide Unhide can be selected by mouse from the menu or by pressing Ctrl-i on the keyboard. A list of cells has to be selected first (see `Selecting Cells'). After this function has been used, the contents of the cells which where hidden with the `Hide' function will made visible again. 5.5.3.10. Protect Protect can be selected by mouse from the menu or by pressing Ctrl-o on the keyboard. A list of cells has to be selected first (see `Selecting Cells'). After this function has been used, the contents selected cells will have the protects status. If the option `Protection Active' from the `Preferences' menu has been activated, the contents of the protected cells can not be changed. 5.5.3.11. Unprotect Unprotect can be selected by mouse from the menu or by pressing Ctrl-t on the keyboard. A list of cells has to be selected first (see `Selecting Cells'). After this function has been used, the contents of the cells which where protected with the `Protect' function will not have the protect status anymore. To Unprotect the protected cells the `Protection Active' from the `Preferences' menu must be disabled. 5.5.4. Graph - Graph - 5.5.4.1. View View will open a window and show a graphic presentation of the data of the current sheet. The `Settings' of the graphic presentation can be set or changed with use of the `Graph Settings-requester'. 5.5.4.1.1. Write As IFF This option should give you the possibility to write your graphic presentation to disk according to the IFF standard. At this moment this option is not active yet, because I have to figure out how to use the IFFParse.library. So if you know how this has to be done explain it to me!! 5.5.4.1.2. Print Print will make a Hardcopy of the current graphic presentation to your printer. 5.5.4.2. Settings Settings will activate the `Graph Settings-requester'. In this way the settings of the graphic presentation of the current sheet can be set or changed. 5.5.5. Preferences - Preferences - 5.5.5.1. Custom screen Custom screen will let you choose if the sheet has to be shown on the Workbench or on a custom screen. 5.5.5.2. Change Screentype Change Screentype will show the asl screen-requester. That is if you use asl.library V38 or up. With this requester the custom screen can be changed to another mode and size. 5.5.5.3. Workbench Workbench will switch the workbench on or of if a custom screen is active. In this way it is possible to free some memory. 5.5.5.4. Autocalc If Autocalc is active every time numeric data is entered or changed a recalculation of the sheet will take place. Otherwise F10 has to be pressed to recalculate the sheet. 5.5.5.5. Show Grid If Show Grid is active the borders of al visible cells will be showed on the sheet. In this way it will be easier to see in what row and column the cursor is. 5.5.5.6. Functionlist Functionlist will show or hide the `Function-requester'. If you hide the `Function-requester' you will have more space for your sheet left. 5.5.5.7. Protection Active If Protection Active has been enabled, the contents of all cells that are protected with `Protect' cannot be changed anymore. 5.5.5.9. Save Icon If Save Icon is enabled an Icon will be written to disk along with the project. 5.5.5.10. Set Currency Symbol Set Currency Symbol will activate `Set Currency Symbol-requester' so the currency symbol can be adjusted. 5.5.5.11. Set Sheet Font Set Sheet Font will show the asl font-requester. With this requester the font type and size of the current sheet can be changed. If you are not using asl.library V38 or better be sure you don't select a proportional font. 5.5.5.12. Save Preferences Save Preferences will write a small file named FHSPrefs to your S: directory. In this file the preference settings and some graph-setting will be saved. 6. Mathematic function describtion AVAILABLE FUNCTIONS: In this chapter all available functions are listed: SIN(val) = Calculates the sine in radian. ASIN(val) = Calculates the arcsine in radian. SINH(val) = Calculates the sinehyperbolic in radian. COS(val) = Calculates the cosine in radian. ACOS(val) = Calculates the arccosine in radian. COSH(val) = Calculates the cosinehyperbolic in radian. TAN(val) = Calculates the tangent in radiant. ATAN(val) = Calculates the arctangent in radian. TANH(val) = Calculates the tangenthyperbolic in radian. RAD(val) = Changes degrees to radian. DEG(val) = Changes radian to degrees. ROUND(val,n) = Will round a numeric value to n digits. MOD(val,n) = Will give the modules n of val. RANDOM(val) = Wil generate a random value between zero and val. EXP(val) = Calculates e^val. LOG(val) = Calculates the natural logarithm of val. LOG10(val) = Calculates the (LOG(val)/LOG(10)). FACT(val) = Calculates val! VARIAT(val,n) = Calculates val!/(val-n)! COMBIN(val,n) = Calculates val!/((val-n)!*n!) AVG(list) = Will calculate the average of all values in the list. 'example (AVG(A1|B3))' SUM(list) = Will sum all values in the list. 'example (SUM(A1|B3))' COUNT(list) = Will count the number of used cells in the list. 'example (COUNT(A1|B3))' There are also a constant value: PI = Will return the value of 3.14....etc. Use F10 (function key number 10) to recalculate the spreadsheet. 7. History - History - Version 0.1 19-05-1996 Released V0.1 First uploaded to Niria BBS. Version 0.2 20-05-1996 Enabled possibility to hardcopy a graphic presentation to printer (See `Print '). 22-05-1996 Upload to AMBBS. The Sysop will try to send my archive to Aminet. Thank you Sysop of the AMBBS. Version 0.31 26-08-96 Fixed a problem with the menu's. Under System 3.1 the mennu's wouldnot show the AMIGA symbole. This should be OK now. (Thanks to Theo Gommans) Version 0.32 07-10-96 Fixed the problem loading fhs sheets from the menu load option. Under WB3.0 the programm only just gave the message `File not found'. This should work fine now.(And it does) (Thanks to the people of AMIGA MAGAZINE NL) Version 0.33 08-10-96 Fixed small cosmetic bug that again only showed up under WB3.0. (Thanks again to the people of AMIGA MAGAZINE NL)